package com.byxm.wlgw.query;

import com.byxm.wlgw.bean.SpxhBean;

public class SpxhQuery {


	public String getSpxhSql(int splbfid){
		StringBuffer sql = new StringBuffer();
		sql.append("select * from spxh where splbfid=").append(splbfid);
		return sql.toString();
	}
	public String getSaveSql(SpxhBean spxhBean){
		StringBuffer sql=new StringBuffer();
		sql.append("insert into spxh(spxhnr,splbfid,px)values('");
		sql.append(spxhBean.getSpxhnr()).append("',");
		sql.append(spxhBean.getSplbfid()).append(",");
		sql.append(spxhBean.getPx());
		sql.append(")");
		return sql.toString();
	}
	public String deleteSql(int xhid){
		StringBuffer sql=new StringBuffer();
		sql.append("delete from spxh where xhid=").append(xhid);
		return sql.toString();
	}
}